Dataset info
| Number of variables | 31 |
|---|---|
| Number of observations | 821723 |
| Missing cells | 2296145 (9.0%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 188.9 MiB |
| Average record size in memory | 241.0 B |
Variables types
| Numeric | 3 |
|---|---|
| Categorical | 24 |
| Boolean | 1 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 3 |
| Unsupported | 0 |
Warnings
age_at_incident has 13351 (1.6%) missing values | Missing |
arraignment_date has a high cardinality: 3206 distinct values | Warning |
arraignment_date has 141443 (17.2%) missing values | Missing |
arrest_date has a high cardinality: 258283 distinct values | Warning |
arrest_date has 17929 (2.2%) missing values | Missing |
case_participant_id is highly correlated with case_id (ρ = 0.9862112296) | Rejected |
charge_disposition_reason has 602411 (73.3%) missing values | Missing |
charge_id is highly correlated with case_participant_id (ρ = 0.9583841653) | Rejected |
charge_version_id is highly correlated with charge_id (ρ = 0.9683668011) | Rejected |
court_facility has 8469 (1.0%) missing values | Missing |
disposition_charged_act has a high cardinality: 52 distinct values | Warning |
disposition_charged_act has 23341 (2.8%) missing values | Missing |
disposition_charged_aoic has a high cardinality: 3298 distinct values | Warning |
disposition_charged_chapter has a high cardinality: 858 distinct values | Warning |
disposition_charged_offense_title has a high cardinality: 2302 distinct values | Warning |
disposition_charged_section has a high cardinality: 1635 distinct values | Warning |
disposition_charged_section has 23341 (2.8%) missing values | Missing |
disposition_date only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
disposition_date has a high cardinality: 2802 distinct values | Warning |
incident_begin_date has a high cardinality: 6465 distinct values | Warning |
incident_city has a high cardinality: 268 distinct values | Warning |
incident_city has 73668 (9.0%) missing values | Missing |
incident_end_date has a high cardinality: 4287 distinct values | Warning |
incident_end_date has 729228 (88.7%) missing values | Missing |
judge has a high cardinality: 403 distinct values | Warning |
judge has 69566 (8.5%) missing values | Missing |
law_enforcement_agency has a high cardinality: 525 distinct values | Warning |
offense_category has a high cardinality: 88 distinct values | Warning |
received_date only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
received_date has a high cardinality: 6033 distinct values | Warning |
unit has a high cardinality: 101 distinct values | Warning |
unit has 571681 (69.6%) missing values | Missing |
updated_offense_category has a high cardinality: 81 distinct values | Warning |
age_at_incident
Numeric
| Distinct count | 88 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 1.6% |
| Missing (n) | 13351 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 31.91356826 |
|---|---|
| Minimum | 17 |
| Maximum | 156 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 17 |
|---|---|
| 5-th percentile | 18 |
| Q1 | 22 |
| Median | 29 |
| Q3 | 39 |
| 95-th percentile | 55 |
| Maximum | 156 |
| Range | 139 |
| Interquartile range | 17 |
Descriptive statistics
| Standard deviation | 11.72520023 |
|---|---|
| Coef of variation | 0.3674048647 |
| Kurtosis | 0.1671993046 |
| Mean | 31.91356826 |
| MAD | 9.628208641 |
| Skewness | 0.8955357052 |
| Sum | 25798035 |
| Variance | 137.4803204 |
| Memory size | 6.3 MiB |
| Value | Count | Frequency (%) | |
| 19 | 44294 | 5.4% | |
| 20 | 43202 | 5.3% | |
| 21 | 39147 | 4.8% | |
| 22 | 36973 | 4.5% | |
| 23 | 36110 | 4.4% | |
| 24 | 33820 | 4.1% | |
| 18 | 32061 | 3.9% | |
| 25 | 31087 | 3.8% | |
| 26 | 30363 | 3.7% | |
| 27 | 28925 | 3.5% | |
| Other values (77) | 452390 | 55.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 17 | 12943 | 1.6% | |
| 18 | 32061 | 3.9% | |
| 19 | 44294 | 5.4% | |
| 20 | 43202 | 5.3% | |
| 21 | 39147 | 4.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 156 | 1 | < 0.1% | |
| 130 | 1 | < 0.1% | |
| 127 | 2 | < 0.1% | |
| 125 | 1 | < 0.1% | |
| 124 | 1 | < 0.1% |
arraignment_date
Categorical
| Distinct count | 3206 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 17.2% |
| Missing (n) | 141443 |
| 2/14/2012 12:00:00 AM | 944 |
|---|---|
| 12/6/2011 12:00:00 AM | 935 |
| 3/20/2014 12:00:00 AM | 896 |
| Other values (3202) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 2/14/2012 12:00:00 AM | 944 | 0.1% | |
| 12/6/2011 12:00:00 AM | 935 | 0.1% | |
| 3/20/2014 12:00:00 AM | 896 | 0.1% | |
| 9/3/2013 12:00:00 AM | 872 | 0.1% | |
| 12/13/2011 12:00:00 AM | 760 | 0.1% | |
| 9/8/2011 12:00:00 AM | 759 | 0.1% | |
| 11/17/2011 12:00:00 AM | 752 | 0.1% | |
| 2/19/2013 12:00:00 AM | 725 | 0.1% | |
| 2/21/2012 12:00:00 AM | 722 | 0.1% | |
| 4/18/2013 12:00:00 AM | 721 | 0.1% | |
| Other values (3195) | 672194 | 81.8% | |
| (Missing) | 141443 | 17.2% |
| Max length | 22 |
|---|---|
| Mean length | 17.85882469 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
arrest_date
Categorical
| Distinct count | 258283 |
|---|---|
| Unique (%) | 31.4% |
| Missing (%) | 2.2% |
| Missing (n) | 17929 |
| 3/10/2012 1:49:00 AM | 326 |
|---|---|
| 4/14/2010 5:51:00 AM | 301 |
| 3/1/2013 11:55:00 AM | 294 |
| Other values (258279) | |
| (Missing) | 17929 |
| Value | Count | Frequency (%) | |
| 3/10/2012 1:49:00 AM | 326 | < 0.1% | |
| 4/14/2010 5:51:00 AM | 301 | < 0.1% | |
| 3/1/2013 11:55:00 AM | 294 | < 0.1% | |
| 1/25/2012 10:40:00 AM | 287 | < 0.1% | |
| 8/1/2013 8:15:00 PM | 262 | < 0.1% | |
| 10/18/2011 9:06:00 AM | 244 | < 0.1% | |
| 12/28/2011 3:30:00 PM | 218 | < 0.1% | |
| 1/2/2011 1:42:00 AM | 216 | < 0.1% | |
| 11/2/2008 4:40:00 AM | 198 | < 0.1% | |
| 3/30/2017 10:58:00 AM | 195 | < 0.1% | |
| Other values (258272) | 801253 | 97.5% | |
| (Missing) | 17929 | 2.2% |
| Max length | 22 |
|---|---|
| Mean length | 19.8829058 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
case_id
Numeric
| Distinct count | 291211 |
|---|---|
| Unique (%) | 35.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.182481192e+11 |
|---|---|
| Minimum | 4.467030971e+10 |
| Maximum | 1.312048319e+11 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 4.467030971e+10 |
|---|---|
| 5-th percentile | 7.185488393e+10 |
| Q1 | 1.163808261e+11 |
| Median | 1.20743827e+11 |
| Q3 | 1.252188738e+11 |
| 95-th percentile | 1.288860775e+11 |
| Maximum | 1.312048319e+11 |
| Range | 8.653452222e+10 |
| Interquartile range | 8838047627 |
Descriptive statistics
| Standard deviation | 1.340114151e+10 |
|---|---|
| Coef of variation | 0.1133306948 |
| Kurtosis | 9.655431823 |
| Mean | 1.182481192e+11 |
| MAD | 7351650408 |
| Skewness | -3.107491641 |
| Sum | 9.716719924e+16 |
| Variance | 1.795905938e+20 |
| Memory size | 6.3 MiB |
| Value | Count | Frequency (%) | |
| 1.158186255e+11 | 430 | 0.1% | |
| 1.261964064e+11 | 400 | < 0.1% | |
| 5.424918312e+10 | 392 | < 0.1% | |
| 1.194551677e+11 | 327 | < 0.1% | |
| 1.207425129e+11 | 320 | < 0.1% | |
| 1.125396841e+11 | 301 | < 0.1% | |
| 1.158679906e+11 | 300 | < 0.1% | |
| 6.360703087e+10 | 297 | < 0.1% | |
| 1.187367686e+11 | 294 | < 0.1% | |
| 1.166253735e+11 | 294 | < 0.1% | |
| Other values (291201) | 818368 | 99.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 4.467030971e+10 | 20 | < 0.1% | |
| 4.475992891e+10 | 7 | < 0.1% | |
| 4.492563245e+10 | 1 | < 0.1% | |
| 4.497236934e+10 | 1 | < 0.1% | |
| 4.532891885e+10 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.312048319e+11 | 1 | < 0.1% | |
| 1.312045691e+11 | 1 | < 0.1% | |
| 1.312044815e+11 | 1 | < 0.1% | |
| 1.312020286e+11 | 1 | < 0.1% | |
| 1.312018972e+11 | 1 | < 0.1% |
case_participant_id
Highly correlated
This variable is highly correlated with case_id and should be ignored for analysis
| Correlation | 0.9862112296 |
|---|
charge_count
Numeric
| Distinct count | 301 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 5.607300757 |
|---|---|
| Minimum | 1 |
| Maximum | 301 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 5 |
| 95-th percentile | 19 |
| Maximum | 301 |
| Range | 300 |
| Interquartile range | 4 |
Descriptive statistics
| Standard deviation | 12.17660369 |
|---|---|
| Coef of variation | 2.171562436 |
| Kurtosis | 116.1180508 |
| Mean | 5.607300757 |
| MAD | 5.349972242 |
| Skewness | 8.708297781 |
| Sum | 4607648 |
| Variance | 148.2696774 |
| Memory size | 6.3 MiB |
| Value | Count | Frequency (%) | |
| 1 | 304534 | 37.1% | |
| 2 | 130317 | 15.9% | |
| 3 | 77082 | 9.4% | |
| 4 | 60487 | 7.4% | |
| 5 | 44012 | 5.4% | |
| 6 | 37213 | 4.5% | |
| 7 | 26410 | 3.2% | |
| 8 | 21673 | 2.6% | |
| 9 | 16220 | 2.0% | |
| 10 | 12947 | 1.6% | |
| Other values (291) | 90828 | 11.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 304534 | 37.1% | |
| 2 | 130317 | 15.9% | |
| 3 | 77082 | 9.4% | |
| 4 | 60487 | 7.4% | |
| 5 | 44012 | 5.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 301 | 1 | < 0.1% | |
| 300 | 1 | < 0.1% | |
| 299 | 1 | < 0.1% | |
| 298 | 1 | < 0.1% | |
| 297 | 1 | < 0.1% |
charge_disposition
Categorical
| Distinct count | 36 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Nolle Prosecution | |
|---|---|
| Plea Of Guilty | |
| FNG | 37557 |
| Other values (33) | 77809 |
| Value | Count | Frequency (%) | |
| Nolle Prosecution | 502967 | 61.2% | |
| Plea Of Guilty | 203390 | 24.8% | |
| FNG | 37557 | 4.6% | |
| FNPC | 34152 | 4.2% | |
| Finding Guilty | 22345 | 2.7% | |
| Verdict Guilty | 4721 | 0.6% | |
| Verdict-Not Guilty | 3943 | 0.5% | |
| Death Suggested-Cause Abated | 3647 | 0.4% | |
| BFW | 2052 | 0.2% | |
| Superseded by Indictment | 1664 | 0.2% | |
| Other values (26) | 5285 | 0.6% |
| Max length | 32 |
|---|---|
| Mean length | 15.03468931 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
charge_disposition_reason
Categorical
| Distinct count | 30 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 73.3% |
| Missing (n) | 602411 |
| PG to Other Count/s | |
|---|---|
| Proceeding on Other Count/s | 33162 |
| Nolle - AONIC | 13811 |
| Other values (26) | 44447 |
| (Missing) |
| Value | Count | Frequency (%) | |
| PG to Other Count/s | 127892 | 15.6% | |
| Proceeding on Other Count/s | 33162 | 4.0% | |
| Nolle - AONIC | 13811 | 1.7% | |
| DGS Graduation | 4692 | 0.6% | |
| Motion to Quash Arrest & Suppress Evidence/Sustained | 4450 | 0.5% | |
| Re-Indictment | 4221 | 0.5% | |
| Misdemeanor Amount | 4138 | 0.5% | |
| Proceeding on Other Case/s | 3727 | 0.5% | |
| Complaining Witness Not in Court | 3668 | 0.4% | |
| No Lab | 3368 | 0.4% | |
| Other values (19) | 16183 | 2.0% | |
| (Missing) | 602411 | 73.3% |
| Max length | 52 |
|---|---|
| Mean length | 7.668299415 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
charge_id
Highly correlated
This variable is highly correlated with case_participant_id and should be ignored for analysis
| Correlation | 0.9583841653 |
|---|
charge_version_id
Highly correlated
This variable is highly correlated with charge_id and should be ignored for analysis
| Correlation | 0.9683668011 |
|---|
court_facility
Categorical
| Distinct count | 17 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 1.0% |
| Missing (n) | 8469 |
| 26TH Street | |
|---|---|
| Markham Courthouse | 79200 |
| Bridgeview Courthouse | 77590 |
| Other values (13) |
| Value | Count | Frequency (%) | |
| 26TH Street | 440181 | 53.6% | |
| Markham Courthouse | 79200 | 9.6% | |
| Bridgeview Courthouse | 77590 | 9.4% | |
| Skokie Courthouse | 75543 | 9.2% | |
| Maywood Courthouse | 47226 | 5.7% | |
| Rolling Meadows Courthouse | 37654 | 4.6% | |
| Harrison & Kedzie (Area 4) | 15174 | 1.8% | |
| 51st & Wentworth (Area 1) | 10914 | 1.3% | |
| Grand & Central (Area 5) | 9650 | 1.2% | |
| 727 E. 111th Street (Area 2) | 8611 | 1.0% | |
| Other values (6) | 11511 | 1.4% | |
| (Missing) | 8469 | 1.0% |
| Max length | 30 |
|---|---|
| Mean length | 15.0265284 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
court_name
Categorical
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.7% |
| Missing (n) | 5550 |
| District 1 - Chicago | |
|---|---|
| District 6 - Markham | 79859 |
| District 5 - Bridgeview | 77708 |
| Other values (5) |
| Value | Count | Frequency (%) | |
| District 1 - Chicago | 495971 | 60.4% | |
| District 6 - Markham | 79859 | 9.7% | |
| District 5 - Bridgeview | 77708 | 9.5% | |
| District 2 - Skokie | 76650 | 9.3% | |
| District 4 - Maywood | 47754 | 5.8% | |
| District 3 - Rolling Meadows | 37828 | 4.6% | |
| PROMIS | 402 | < 0.1% | |
| Traffic | 1 | < 0.1% | |
| (Missing) | 5550 | 0.7% |
| Max length | 28 |
|---|---|
| Mean length | 20.4370171 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
disposition_charged_act
Categorical
| Distinct count | 52 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 2.8% |
| Missing (n) | 23341 |
| 5 | |
|---|---|
| 570 | |
| 550 | 24394 |
| Other values (48) | 12765 |
| (Missing) | 23341 |
| Value | Count | Frequency (%) | |
| 5 | 600690 | 73.1% | |
| 570 | 160533 | 19.5% | |
| 550 | 24394 | 3.0% | |
| 150 | 3972 | 0.5% | |
| 335 | 1959 | 0.2% | |
| 65 | 1876 | 0.2% | |
| 646 | 1486 | 0.2% | |
| 250 | 1371 | 0.2% | |
| 154 | 474 | 0.1% | |
| 70 | 369 | < 0.1% | |
| Other values (41) | 1258 | 0.2% | |
| (Missing) | 23341 | 2.8% |
| Max length | 5 |
|---|---|
| Mean length | 1.53471547 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
disposition_charged_aoic
Categorical
| Distinct count | 3298 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | < 0.1% |
| Missing (n) | 193 |
| 5101110 | 103600 |
|---|---|
| 0012476 | 22523 |
| 0014717 | 21035 |
| Other values (3294) |
| Value | Count | Frequency (%) | |
| 5101110 | 103600 | 12.6% | |
| 0012476 | 22523 | 2.7% | |
| 0014717 | 21035 | 2.6% | |
| 0012309 | 18769 | 2.3% | |
| 0735000 | 18494 | 2.3% | |
| 0016108 | 17439 | 2.1% | |
| 0012474 | 17283 | 2.1% | |
| 5097200 | 16471 | 2.0% | |
| 0014716 | 15720 | 1.9% | |
| 0014056 | 15068 | 1.8% | |
| Other values (3287) | 555128 | 67.6% |
| Max length | 10 |
|---|---|
| Mean length | 7.156510162 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
disposition_charged_chapter
Categorical
| Distinct count | 858 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 720 | |
|---|---|
| 625 | 111167 |
| 730 | 9316 |
| Other values (855) | 28636 |
| Value | Count | Frequency (%) | |
| 720 | 672604 | 81.9% | |
| 625 | 111167 | 13.5% | |
| 730 | 9316 | 1.1% | |
| 720-5\8-4(720-5\9-1) | 2514 | 0.3% | |
| 15 | 1959 | 0.2% | |
| 430 | 1917 | 0.2% | |
| 720-570\402(C) | 940 | 0.1% | |
| 720-5\10-3.1 | 885 | 0.1% | |
| 720-5\18-2(A)(2) | 794 | 0.1% | |
| 720-5\12-4(A) | 780 | 0.1% | |
| Other values (848) | 18847 | 2.3% |
| Max length | 24 |
|---|---|
| Mean length | 3.357978297 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
disposition_charged_class
Categorical
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 170 |
| 4 | |
|---|---|
| 2 | |
| 3 | |
| Other values (10) |
| Value | Count | Frequency (%) | |
| 4 | 341449 | 41.6% | |
| 2 | 174458 | 21.2% | |
| 3 | 122749 | 14.9% | |
| X | 78539 | 9.6% | |
| 1 | 64240 | 7.8% | |
| M | 22303 | 2.7% | |
| A | 16428 | 2.0% | |
| B | 739 | 0.1% | |
| C | 455 | 0.1% | |
| Z | 115 | < 0.1% | |
| Other values (3) | 78 | < 0.1% | |
| (Missing) | 170 | < 0.1% |
| Max length | 3 |
|---|---|
| Mean length | 1.000413765 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
disposition_charged_offense_title
Categorical
| Distinct count | 2302 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| POSSESSION OF A CONTROLLED SUBSTANCE | 105281 |
|---|---|
| AGGRAVATED UNLAWFUL USE OF WEAPON | 98855 |
| AGGRAVATED DRIVING UNDER THE INFLUENCE OF ALCOHOL | 54853 |
| Other values (2299) |
| Value | Count | Frequency (%) | |
| POSSESSION OF A CONTROLLED SUBSTANCE | 105281 | 12.8% | |
| AGGRAVATED UNLAWFUL USE OF WEAPON | 98855 | 12.0% | |
| AGGRAVATED DRIVING UNDER THE INFLUENCE OF ALCOHOL | 54853 | 6.7% | |
| AGGRAVATED BATTERY | 45636 | 5.6% | |
| FELONY DRIVING WHILE DRIVER?S LICENSE, PERMIT, OR PRIVILEGE TO OPERATE A MOTOR VEHICLE IS SUSPENDED OR REVOKED | 37911 | 4.6% | |
| UNLAWFUL USE OR POSSESSION OF A WEAPON BY A FELON | 35566 | 4.3% | |
| [POSSESSION OF CONTROLLED SUBSTANCE WITH INTENT TO DELIVER/DELIVERY OF A CONTROLLED SUBSTANCE] | 25699 | 3.1% | |
| RETAIL THEFT | 21282 | 2.6% | |
| THEFT | 18581 | 2.3% | |
| [POSSESSION OF CONTROLLED SUBSTANCE WITH INTENT TO DELIVER/ DELIVERY OF A CONTROLLED SUBSTANCE] | 17002 | 2.1% | |
| Other values (2292) | 361057 | 43.9% |
| Max length | 120 |
|---|---|
| Mean length | 38.8769634 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
disposition_charged_section
Categorical
| Distinct count | 1635 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 2.8% |
| Missing (n) | 23341 |
| 402(c) | 102823 |
|---|---|
| 24-1.6(a)(1) | 72148 |
| 11-501(a) | 55022 |
| Other values (1631) |
| Value | Count | Frequency (%) | |
| 402(c) | 102823 | 12.5% | |
| 24-1.6(a)(1) | 72148 | 8.8% | |
| 11-501(a) | 55022 | 6.7% | |
| 6-303(a) | 40748 | 5.0% | |
| 24-1.1(a) | 35566 | 4.3% | |
| 24-1.6(a)(2) | 35365 | 4.3% | |
| 16-25(a)(1) | 17456 | 2.1% | |
| 12-3.05(d)(4) | 17394 | 2.1% | |
| 401(d)(i) | 16402 | 2.0% | |
| 8-4(a)(720-5/9-1(a)(1)) | 12253 | 1.5% | |
| Other values (1624) | 393205 | 47.9% | |
| (Missing) | 23341 | 2.8% |
| Max length | 30 |
|---|---|
| Mean length | 9.444253112 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
disposition_date
Categorical
| Distinct count | 2802 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 10/30/2013 12:00:00 AM | 801 |
|---|---|
| 5/11/2012 12:00:00 AM | 760 |
| 7/10/2014 12:00:00 AM | 733 |
| Other values (2799) |
| Value | Count | Frequency (%) | |
| 10/30/2013 12:00:00 AM | 801 | 0.1% | |
| 5/11/2012 12:00:00 AM | 760 | 0.1% | |
| 7/10/2014 12:00:00 AM | 733 | 0.1% | |
| 9/17/2013 12:00:00 AM | 726 | 0.1% | |
| 12/5/2013 12:00:00 AM | 705 | 0.1% | |
| 10/6/2016 12:00:00 AM | 692 | 0.1% | |
| 4/13/2016 12:00:00 AM | 687 | 0.1% | |
| 4/18/2013 12:00:00 AM | 685 | 0.1% | |
| 8/29/2012 12:00:00 AM | 680 | 0.1% | |
| 10/24/2013 12:00:00 AM | 679 | 0.1% | |
| Other values (2792) | 814575 | 99.1% |
| Max length | 22 |
|---|---|
| Mean length | 20.95091412 |
| Min length | 20 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
gender
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 2945 |
| Male | |
|---|---|
| Female | 87228 |
| Male name, no gender given | 9 |
| Other values (2) | 9 |
| (Missing) | 2945 |
| Value | Count | Frequency (%) | |
| Male | 731532 | 89.0% | |
| Female | 87228 | 10.6% | |
| Male name, no gender given | 9 | < 0.1% | |
| Unknown | 7 | < 0.1% | |
| Unknown Gender | 2 | < 0.1% | |
| (Missing) | 2945 | 0.4% |
| Max length | 26 |
|---|---|
| Mean length | 4.209012039 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
incident_begin_date
Categorical
| Distinct count | 6465 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.9% |
| Missing (n) | 7614 |
| 1/1/2012 12:00:00 AM | 782 |
|---|---|
| 1/1/2013 12:00:00 AM | 705 |
| 10/18/2011 12:00:00 AM | 655 |
| Other values (6461) | |
| (Missing) | 7614 |
| Value | Count | Frequency (%) | |
| 1/1/2012 12:00:00 AM | 782 | 0.1% | |
| 1/1/2013 12:00:00 AM | 705 | 0.1% | |
| 10/18/2011 12:00:00 AM | 655 | 0.1% | |
| 1/19/2017 12:00:00 AM | 610 | 0.1% | |
| 9/10/2011 12:00:00 AM | 597 | 0.1% | |
| 1/1/2011 12:00:00 AM | 593 | 0.1% | |
| 1/1/2010 12:00:00 AM | 581 | 0.1% | |
| 8/4/2011 12:00:00 AM | 558 | 0.1% | |
| 9/1/2010 12:00:00 AM | 556 | 0.1% | |
| 12/27/2011 12:00:00 AM | 552 | 0.1% | |
| Other values (6454) | 807920 | 98.3% | |
| (Missing) | 7614 | 0.9% |
| Max length | 22 |
|---|---|
| Mean length | 20.76304545 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
incident_city
Categorical
| Distinct count | 268 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 9.0% |
| Missing (n) | 73668 |
| Chicago | |
|---|---|
| Cicero | 10716 |
| Harvey | 7704 |
| Other values (264) | |
| (Missing) | 73668 |
| Value | Count | Frequency (%) | |
| Chicago | 535463 | 65.2% | |
| Cicero | 10716 | 1.3% | |
| Harvey | 7704 | 0.9% | |
| Chicago Heights | 6314 | 0.8% | |
| Calumet City | 5638 | 0.7% | |
| Berwyn | 5173 | 0.6% | |
| Orland Park | 5005 | 0.6% | |
| Oak Lawn | 4751 | 0.6% | |
| Evanston | 4511 | 0.5% | |
| Dolton | 4342 | 0.5% | |
| Other values (257) | 158438 | 19.3% | |
| (Missing) | 73668 | 9.0% |
| Max length | 21 |
|---|---|
| Mean length | 7.347203376 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
incident_end_date
Categorical
| Distinct count | 4287 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 88.7% |
| Missing (n) | 729228 |
| 2/28/2013 12:00:00 AM | 441 |
|---|---|
| 1/19/2017 12:00:00 AM | 408 |
| 7/7/2004 12:00:00 AM | 392 |
| Other values (4283) | 91254 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 2/28/2013 12:00:00 AM | 441 | 0.1% | |
| 1/19/2017 12:00:00 AM | 408 | < 0.1% | |
| 7/7/2004 12:00:00 AM | 392 | < 0.1% | |
| 8/22/2011 12:00:00 AM | 389 | < 0.1% | |
| 9/11/2011 12:00:00 AM | 321 | < 0.1% | |
| 1/31/2007 12:00:00 AM | 294 | < 0.1% | |
| 3/12/2014 12:00:00 AM | 250 | < 0.1% | |
| 10/31/2014 12:00:00 AM | 217 | < 0.1% | |
| 7/23/2014 12:00:00 AM | 201 | < 0.1% | |
| 11/2/2008 12:00:00 AM | 198 | < 0.1% | |
| Other values (4276) | 89384 | 10.9% | |
| (Missing) | 729228 | 88.7% |
| Max length | 22 |
|---|---|
| Mean length | 5.021989162 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
judge
Categorical
| Distinct count | 403 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 8.5% |
| Missing (n) | 69566 |
| Brian K Flaherty | 22254 |
|---|---|
| James B Linn | 19711 |
| Michele M Pitman | 19173 |
| Other values (399) | |
| (Missing) | 69566 |
| Value | Count | Frequency (%) | |
| Brian K Flaherty | 22254 | 2.7% | |
| James B Linn | 19711 | 2.4% | |
| Michele M Pitman | 19173 | 2.3% | |
| Nicholas R Ford | 18793 | 2.3% | |
| Colleen Ann Hyland | 16314 | 2.0% | |
| James Michael Obbish | 15250 | 1.9% | |
| Joseph Michael Claps | 14873 | 1.8% | |
| Charles P Burns | 14554 | 1.8% | |
| Vincent M Gaughan | 14412 | 1.8% | |
| Kenneth J Wadas | 14371 | 1.7% | |
| Other values (392) | 582452 | 70.9% | |
| (Missing) | 69566 | 8.5% |
| Max length | 25 |
|---|---|
| Mean length | 15.43718382 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
law_enforcement_agency
Categorical
| Distinct count | 525 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.1% |
| Missing (n) | 1062 |
| CHICAGO PD | |
|---|---|
| COOK COUNTY SHERIFF (IL0160000) | 19804 |
| CICERO PD | 10908 |
| Other values (521) |
| Value | Count | Frequency (%) | |
| CHICAGO PD | 527681 | 64.2% | |
| COOK COUNTY SHERIFF (IL0160000) | 19804 | 2.4% | |
| CICERO PD | 10908 | 1.3% | |
| HARVEY PD | 6713 | 0.8% | |
| CHICAGO HEIGHTS PD | 6267 | 0.8% | |
| ORLAND PARK PD | 5626 | 0.7% | |
| CALUMET CITY PD | 5353 | 0.7% | |
| ISP DISTRICT CHICAGO | 5333 | 0.6% | |
| BERWYN PD | 5100 | 0.6% | |
| EVANSTON PD | 4810 | 0.6% | |
| Other values (514) | 223066 | 27.1% |
| Max length | 60 |
|---|---|
| Mean length | 12.31936188 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
offense_category
Categorical
| Distinct count | 88 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Narcotics | |
|---|---|
| UUW - Unlawful Use of Weapon | |
| Aggravated DUI | 51759 |
| Other values (85) |
| Value | Count | Frequency (%) | |
| Narcotics | 178419 | 21.7% | |
| UUW - Unlawful Use of Weapon | 143369 | 17.4% | |
| Aggravated DUI | 51759 | 6.3% | |
| PROMIS Conversion | 47380 | 5.8% | |
| Sex Crimes | 35874 | 4.4% | |
| Driving With Suspended Or Revoked License | 30798 | 3.7% | |
| Armed Robbery | 25212 | 3.1% | |
| Aggravated Battery Police Officer | 23070 | 2.8% | |
| Retail Theft | 23025 | 2.8% | |
| Homicide | 22090 | 2.7% | |
| Other values (78) | 240727 | 29.3% |
| Max length | 45 |
|---|---|
| Mean length | 17.29490351 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
primary_charge
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) | |
| False | 517189 | 62.9% | |
| True | 304534 | 37.1% |
race
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.5% |
| Missing (n) | 4183 |
| Black | |
|---|---|
| White [Hispanic or Latino] | |
| White | 107873 |
| Other values (8) | 30178 |
| Value | Count | Frequency (%) | |
| Black | 547288 | 66.6% | |
| White [Hispanic or Latino] | 132201 | 16.1% | |
| White | 107873 | 13.1% | |
| HISPANIC | 18937 | 2.3% | |
| Asian | 5168 | 0.6% | |
| White/Black [Hispanic or Latino] | 4110 | 0.5% | |
| Unknown | 1141 | 0.1% | |
| American Indian | 427 | 0.1% | |
| ASIAN | 279 | < 0.1% | |
| Biracial | 115 | < 0.1% | |
| (Missing) | 4183 | 0.5% |
| Max length | 32 |
|---|---|
| Mean length | 8.580931774 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
received_date
Categorical
| Distinct count | 6033 |
|---|---|
| Unique (%) | 0.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 10/18/2011 12:00:00 AM | 877 |
|---|---|
| 8/23/2011 12:00:00 AM | 723 |
| 8/5/2011 12:00:00 AM | 705 |
| Other values (6030) |
| Value | Count | Frequency (%) | |
| 10/18/2011 12:00:00 AM | 877 | 0.1% | |
| 8/23/2011 12:00:00 AM | 723 | 0.1% | |
| 8/5/2011 12:00:00 AM | 705 | 0.1% | |
| 1/25/2012 12:00:00 AM | 687 | 0.1% | |
| 11/16/2011 12:00:00 AM | 641 | 0.1% | |
| 6/28/2013 12:00:00 AM | 638 | 0.1% | |
| 1/21/2017 12:00:00 AM | 630 | 0.1% | |
| 8/28/2012 12:00:00 AM | 613 | 0.1% | |
| 10/21/2013 12:00:00 AM | 587 | 0.1% | |
| 7/30/2012 12:00:00 AM | 570 | 0.1% | |
| Other values (6023) | 815052 | 99.2% |
| Max length | 22 |
|---|---|
| Mean length | 20.94496199 |
| Min length | 20 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
unit
Categorical
| Distinct count | 101 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 69.6% |
| Missing (n) | 571681 |
| District 11 - Harrison | 48071 |
|---|---|
| District 10 - Ogden | 20216 |
| District 15 - Austin | 18183 |
| Other values (97) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| District 11 - Harrison | 48071 | 5.9% | |
| District 10 - Ogden | 20216 | 2.5% | |
| District 15 - Austin | 18183 | 2.2% | |
| District 7 - Englewood | 17160 | 2.1% | |
| District 6 - Gresham | 14477 | 1.8% | |
| District 25 - Grand Central | 13682 | 1.7% | |
| District 8 - Chicago Lawn | 11383 | 1.4% | |
| District 9 - Deering | 11377 | 1.4% | |
| District 5 - Calumet | 11182 | 1.4% | |
| District 4 - South Chicago | 9813 | 1.2% | |
| Other values (90) | 74498 | 9.1% | |
| (Missing) | 571681 | 69.6% |
| Max length | 57 |
|---|---|
| Mean length | 9.043476938 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
updated_offense_category
Categorical
| Distinct count | 81 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Narcotics | |
|---|---|
| UUW - Unlawful Use of Weapon | |
| Aggravated DUI | 65161 |
| Other values (78) |
| Value | Count | Frequency (%) | |
| Narcotics | 188762 | 23.0% | |
| UUW - Unlawful Use of Weapon | 148956 | 18.1% | |
| Aggravated DUI | 65161 | 7.9% | |
| Sex Crimes | 39498 | 4.8% | |
| Homicide | 31552 | 3.8% | |
| Driving With Suspended Or Revoked License | 31409 | 3.8% | |
| Aggravated Battery With A Firearm | 29055 | 3.5% | |
| Armed Robbery | 26005 | 3.2% | |
| Aggravated Battery Police Officer | 24684 | 3.0% | |
| Retail Theft | 22396 | 2.7% | |
| Other values (71) | 214245 | 26.1% |
| Max length | 45 |
|---|---|
| Mean length | 17.5830651 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
First rows
| age_at_incident | arraignment_date | arrest_date | case_id | case_participant_id | charge_count | charge_disposition | charge_disposition_reason | charge_id | charge_version_id | court_facility | court_name | disposition_charged_act | disposition_charged_aoic | disposition_charged_chapter | disposition_charged_class | disposition_charged_offense_title | disposition_charged_section | disposition_date | gender | incident_begin_date | incident_city | incident_end_date | judge | law_enforcement_agency | offense_category | primary_charge | race | received_date | unit | updated_offense_category | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 43.0 | 2/1/2012 12:00:00 AM | 12/29/2011 12:10:00 PM | 116240177428 | 908314430833 | 1 | Nolle Prosecution | Proceeding on Other Count/s | 2077894472647 | 472118710537 | 26TH Street | District 1 - Chicago | 5 | 0012300 | 720 | 2 | AGGRAVATED DOMESTIC BATTERY | 12-3.3(a) | 9/25/2012 12:00:00 AM | Male | 12/8/2011 12:00:00 AM | Chicago | NaN | Vincent M Gaughan | CHICAGO PD | Domestic Battery | True | Black | 1/3/2012 12:00:00 AM | NaN | Domestic Battery |
| 1 | 42.0 | 1/31/2012 12:00:00 AM | 1/3/2012 12:05:00 PM | 116240221230 | 908314782607 | 1 | Plea Of Guilty | NaN | 2074969691100 | 471445411764 | 26TH Street | District 1 - Chicago | 5 | 0015600 | 720 | 4 | RETAIL THEFT | 16A-3(a) | 6/22/2012 12:00:00 AM | Male | 1/3/2012 12:00:00 AM | Chicago | NaN | Michael Brown | CHICAGO PD | Retail Theft | True | Black | 1/3/2012 12:00:00 AM | NaN | Retail Theft |
| 2 | 50.0 | 2/9/2012 12:00:00 AM | 12/29/2011 11:55:00 AM | 116240265032 | 908315368896 | 1 | Plea Of Guilty | NaN | 2074970874144 | 471445680278 | 26TH Street | District 1 - Chicago | 570 | 5101110 | 720 | 4 | POSSESSION OF A CONTROLLED SUBSTANCE | 402(c) | 7/18/2012 12:00:00 AM | Male | 12/29/2011 12:00:00 AM | Chicago | NaN | William H Hooks | CHICAGO PD | Narcotics | True | Black | 1/3/2012 12:00:00 AM | District 12 - Monroe | Narcotics |
| 3 | 28.0 | 2/8/2012 12:00:00 AM | 12/29/2011 2:11:00 PM | 116240352636 | 908315720670 | 1 | Plea Of Guilty | NaN | 2074973831755 | 471446351563 | 26TH Street | District 1 - Chicago | 550 | 5020300 | 720 | 3 | [POSSESSION OF CANNABIS WITH INTENT TO DELIVER/DELIVERY OF CANNABIS] | 5(d) | 9/27/2012 12:00:00 AM | Male | 12/29/2011 12:00:00 AM | Chicago | NaN | William H Hooks | CHICAGO PD | Narcotics | True | Black | 1/3/2012 12:00:00 AM | District 4 - South Chicago | Narcotics |
| 4 | 25.0 | 2/8/2012 12:00:00 AM | 12/29/2011 11:00:00 AM | 116240396439 | 908316658734 | 1 | Plea Of Guilty | NaN | 2074979451216 | 487873767563 | 26TH Street | District 1 - Chicago | 570 | 5101110 | 720 | 4 | POSSESSION OF A CONTROLLED SUBSTANCE | 402(c) | 1/3/2013 12:00:00 AM | Male | 12/29/2011 12:00:00 AM | Chicago | NaN | Raymond Myles | CHICAGO PD | Narcotics | True | Black | 1/3/2012 12:00:00 AM | District 11 - Harrison | Narcotics |
| 5 | 18.0 | 2/8/2012 12:00:00 AM | 12/29/2011 11:00:00 AM | 116240396439 | 908317010508 | 1 | Plea Of Guilty | NaN | 2074979451216 | 471447627005 | 26TH Street | District 1 - Chicago | 570 | 0013009 | 720 | 1 | [POSSESSION OF CONTROLLED SUBSTANCE WITH INTENT TO DELIVER/DELIVERY OF A CONTROLLED SUBSTANCE] | 401(c)(1) | 2/22/2012 12:00:00 AM | Female | 12/29/2011 12:00:00 AM | Chicago | NaN | Raymond Myles | CHICAGO PD | Narcotics | True | Black | 1/3/2012 12:00:00 AM | District 11 - Harrison | Narcotics |
| 6 | 23.0 | 2/14/2012 12:00:00 AM | 12/27/2011 10:00:00 AM | 116240440241 | 908317479540 | 2 | Nolle Prosecution | NaN | 2076733610318 | 471849525285 | 26TH Street | District 1 - Chicago | 5 | 0012300 | 720 | 2 | AGGRAVATED DOMESTIC BATTERY | 12-3.3(a) | 6/20/2013 12:00:00 AM | Male | 12/16/2011 12:00:00 AM | Chicago | NaN | James Michael Obbish | CHICAGO PD | Aggravated Battery | False | Black | 1/3/2012 12:00:00 AM | NaN | Domestic Battery |
| 7 | 23.0 | 2/14/2012 12:00:00 AM | 12/27/2011 10:00:00 AM | 116240440241 | 908317479540 | 3 | Nolle Prosecution | NaN | 2077257107470 | 471970960727 | 26TH Street | District 1 - Chicago | 5 | 0014834 | 720 | 2 | AGGRAVATED DOMESTIC BATTERY | 12-3.3(a-5) | 6/20/2013 12:00:00 AM | Male | 12/16/2011 12:00:00 AM | Chicago | NaN | James Michael Obbish | CHICAGO PD | Aggravated Battery | False | Black | 1/3/2012 12:00:00 AM | NaN | Domestic Battery |
| 8 | 23.0 | 2/14/2012 12:00:00 AM | 12/27/2011 10:00:00 AM | 116240440241 | 908317479540 | 4 | Nolle Prosecution | NaN | 2079629703038 | 472517856549 | 26TH Street | District 1 - Chicago | 5 | 0014834 | 720 | 2 | AGGRAVATED DOMESTIC BATTERY | 12-3.3(a-5) | 6/20/2013 12:00:00 AM | Male | 12/16/2011 12:00:00 AM | Chicago | NaN | James Michael Obbish | CHICAGO PD | Aggravated Battery | False | Black | 1/3/2012 12:00:00 AM | NaN | Domestic Battery |
| 9 | 23.0 | 2/14/2012 12:00:00 AM | 12/27/2011 10:00:00 AM | 116240440241 | 908317479540 | 5 | Nolle Prosecution | NaN | 2076733906079 | 471849592413 | 26TH Street | District 1 - Chicago | 5 | 0016094 | 720 | 3 | AGGRAVATED BATTERY | 12-3.05(a)(1) | 6/20/2013 12:00:00 AM | Male | 12/16/2011 12:00:00 AM | Chicago | NaN | James Michael Obbish | CHICAGO PD | Aggravated Battery | False | Black | 1/3/2012 12:00:00 AM | NaN | Domestic Battery |
Last rows
| age_at_incident | arraignment_date | arrest_date | case_id | case_participant_id | charge_count | charge_disposition | charge_disposition_reason | charge_id | charge_version_id | court_facility | court_name | disposition_charged_act | disposition_charged_aoic | disposition_charged_chapter | disposition_charged_class | disposition_charged_offense_title | disposition_charged_section | disposition_date | gender | incident_begin_date | incident_city | incident_end_date | judge | law_enforcement_agency | offense_category | primary_charge | race | received_date | unit | updated_offense_category | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 821713 | 24.0 | NaN | 10/17/2019 5:25:00 PM | 131198874833 | 1101045483863 | 1 | Nolle Prosecution | NaN | 2584493314237 | 589445217220 | NaN | District 1 - Chicago | 570 | 5101110 | 720 | 4 | POSSESSION OF A CONTROLLED SUBSTANCE | 402(c) | 10/18/2019 12:00:00 AM | Female | 10/17/2019 12:00:00 AM | Chicago | 10/17/2019 12:00:00 AM | NaN | CHICAGO PD | Narcotics | True | White | 11/21/2019 12:00:00 AM | NaN | Narcotics |
| 821714 | 28.0 | NaN | 10/6/2019 1:03:00 PM | 131199050042 | 1101046890958 | 1 | Nolle Prosecution | NaN | 2584493905759 | 589445418605 | NaN | District 1 - Chicago | 570 | 5101110 | 720 | 4 | POSSESSION OF A CONTROLLED SUBSTANCE | 402(c) | 10/7/2019 12:00:00 AM | Male | 10/6/2019 12:00:00 AM | Chicago | 10/6/2019 12:00:00 AM | NaN | CHICAGO PD | Narcotics | True | Black | 11/21/2019 12:00:00 AM | NaN | Narcotics |
| 821715 | 26.0 | NaN | 10/6/2019 1:03:00 PM | 131199444261 | 1101052167567 | 1 | Nolle Prosecution | NaN | 2584499525220 | 589446895432 | NaN | District 1 - Chicago | 570 | 5101110 | 720 | 4 | POSSESSION OF A CONTROLLED SUBSTANCE | 402(c) | 10/7/2019 12:00:00 AM | Female | 10/6/2019 12:00:00 AM | Chicago | 10/6/2019 12:00:00 AM | NaN | CHICAGO PD | Narcotics | True | Black | 11/21/2019 12:00:00 AM | NaN | Narcotics |
| 821716 | 65.0 | NaN | 11/6/2019 11:01:00 AM | 131199575668 | 1101053105631 | 1 | Nolle Prosecution | NaN | 2584500116742 | 589447163946 | NaN | District 1 - Chicago | 570 | 5101110 | 720 | 4 | POSSESSION OF A CONTROLLED SUBSTANCE | 402(c) | 11/7/2019 12:00:00 AM | Male | 11/6/2019 12:00:00 AM | Chicago | 11/6/2019 12:00:00 AM | NaN | CHICAGO PD | Narcotics | True | Black | 11/21/2019 12:00:00 AM | NaN | Narcotics |
| 821717 | 56.0 | NaN | 11/5/2019 11:17:00 AM | 131199838481 | 1101056388854 | 1 | Nolle Prosecution | Misdemeanor Amount | 2584509581097 | 589449312058 | NaN | District 1 - Chicago | 570 | 5101110 | 720 | 4 | POSSESSION OF A CONTROLLED SUBSTANCE | 402(c) | 11/6/2019 12:00:00 AM | Female | 11/5/2019 12:00:00 AM | Chicago | 11/5/2019 12:00:00 AM | NaN | CHICAGO PD | Narcotics | True | Black | 11/21/2019 12:00:00 AM | NaN | Narcotics |
| 821718 | 62.0 | NaN | 11/6/2019 2:36:00 PM | 131201897182 | 1101083006411 | 1 | Nolle Prosecution | NaN | 2584590915401 | 589468040907 | 26TH Street | District 1 - Chicago | 570 | 5101110 | 720 | 4 | POSSESSION OF A CONTROLLED SUBSTANCE | 402(c) | 11/7/2019 12:00:00 AM | Male | 11/6/2019 12:00:00 AM | Chicago | 11/6/2019 12:00:00 AM | NaN | CHICAGO PD | Narcotics | True | Black | 11/21/2019 12:00:00 AM | NaN | Narcotics |
| 821719 | 31.0 | NaN | 11/6/2019 2:13:00 PM | 131202028588 | 1101084648023 | 1 | Nolle Prosecution | NaN | 2584594760295 | 589469114963 | NaN | District 1 - Chicago | 570 | 5101110 | 720 | 4 | POSSESSION OF A CONTROLLED SUBSTANCE | 402(c) | 11/7/2019 12:00:00 AM | Male | 11/6/2019 12:00:00 AM | Chicago | 11/6/2019 12:00:00 AM | NaN | CHICAGO PD | Narcotics | True | Black | 11/21/2019 12:00:00 AM | NaN | Narcotics |
| 821720 | 18.0 | NaN | 11/6/2019 2:08:00 PM | 131204481509 | 1101121467024 | 1 | Nolle Prosecution | NaN | 2584653616754 | 589482876304 | NaN | District 1 - Chicago | 570 | 5101110 | 720 | 4 | POSSESSION OF A CONTROLLED SUBSTANCE | 402(c) | 11/7/2019 12:00:00 AM | Male | 11/6/2019 12:00:00 AM | Chicago | 11/6/2019 12:00:00 AM | NaN | CHICAGO PD | Narcotics | True | Black | 11/22/2019 12:00:00 AM | NaN | Narcotics |
| 821721 | 27.0 | NaN | 11/6/2019 6:27:00 PM | 131204569113 | 1101123108635 | 1 | Nolle Prosecution | NaN | 2584658940454 | 589484151745 | NaN | District 1 - Chicago | 570 | 5101110 | 720 | 4 | POSSESSION OF A CONTROLLED SUBSTANCE | 402(c) | 11/7/2019 12:00:00 AM | Male | 11/6/2019 12:00:00 AM | Chicago | 11/6/2019 12:00:00 AM | NaN | CHICAGO PD | Narcotics | True | Black | 11/22/2019 12:00:00 AM | NaN | Narcotics |
| 821722 | 39.0 | NaN | 10/17/2019 12:47:00 PM | 131204831926 | 1101125805568 | 1 | Nolle Prosecution | NaN | 2584662193826 | 589484890159 | NaN | District 1 - Chicago | 570 | 5101110 | 720 | 4 | POSSESSION OF A CONTROLLED SUBSTANCE | 402(c) | 11/18/2019 12:00:00 AM | Female | 10/17/2019 12:00:00 AM | Chicago | 10/17/2019 12:00:00 AM | NaN | CHICAGO PD | Narcotics | True | Black | 11/22/2019 12:00:00 AM | NaN | Narcotics |